I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the LOWER() function today. The LOWER() function takes a source string as input and returns a output string with all alpha characters converted to lower case. The following example converts the favorite movie title of mine to lower case. [crayon-66485aa608c4d956308755/] [crayon-66485aa608c56700474350/] One thing to always worry about when using TSQL functions is how will it react with empty strings or NULL values? Both empty strings and NULL values as … Continue reading String Functions – LOWER()